/*
 Navicat MySQL Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 80019
 Source Host           : localhost
 Source Database       : fw_pipe

 Target Server Type    : MySQL
 Target Server Version : 80019
 File Encoding         : utf-8

 Date: 12/14/2020 20:33:20 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `area_ph`
-- ----------------------------
DROP TABLE IF EXISTS `area_ph`;
CREATE TABLE `area_ph` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `tj_ins_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '统计实例标识',
  `area_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '区域标识',
  `area_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '区域名称',
  `ph_val` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'PH值',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='酸碱度';

-- ----------------------------
--  Records of `area_ph`
-- ----------------------------
BEGIN;
INSERT INTO `area_ph` VALUES ('1', 'tjInsId1', 'area1', '区一', '200'), ('2', 'tjInsId2', 'area2', '区二', '200'), ('3', 'tjInsId3', 'area3', '区三', '200'), ('4', 'tjInsId4', 'area4', '区四', '300'), ('5', 'b5906ce17d474bc8b380dfa7421ba4f8', 'area1', '区一', '200'), ('6', 'b5906ce17d474bc8b380dfa7421ba4f8', 'area2', '区二', '200'), ('7', 'b5906ce17d474bc8b380dfa7421ba4f8', 'area3', '区三', '200'), ('8', 'b5906ce17d474bc8b380dfa7421ba4f8', 'area4', '区四', '300'), ('9', '06ac0502310649049e0f8d2cc80f48a9', 'area1', '区一', '201'), ('10', '06ac0502310649049e0f8d2cc80f48a9', 'area2', '区二', '201'), ('11', '06ac0502310649049e0f8d2cc80f48a9', 'area3', '区三', '201'), ('12', '06ac0502310649049e0f8d2cc80f48a9', 'area4', '区四', '301'), ('13', 'e1c7379017034060af69bcfbb90a5ef6', '1', '区域一', '2'), ('14', 'e1c7379017034060af69bcfbb90a5ef6', '2', '区域二', '2'), ('15', 'e1c7379017034060af69bcfbb90a5ef6', '3', '区域三', '2'), ('16', 'e1c7379017034060af69bcfbb90a5ef6', '4', '区域四', '2'), ('21', '9a4664723fcf4724a573a4b86ddf98a0', '1', '区域一', '300'), ('22', '9a4664723fcf4724a573a4b86ddf98a0', '2', '区域二', '300'), ('23', '9a4664723fcf4724a573a4b86ddf98a0', '3', '区域三', '300'), ('24', '9a4664723fcf4724a573a4b86ddf98a0', '4', '区域四', '300');
COMMIT;

-- ----------------------------
--  Table structure for `duhai_rondu`
-- ----------------------------
DROP TABLE IF EXISTS `duhai_rondu`;
CREATE TABLE `duhai_rondu` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `tj_ins_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '统计实例标识',
  `month_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '月份标识',
  `h2s_val` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'H2S值',
  `ch2_val` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'CH2值',
  `co_val` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'CO值',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='毒害物质浓度';

-- ----------------------------
--  Records of `duhai_rondu`
-- ----------------------------
BEGIN;
INSERT INTO `duhai_rondu` VALUES ('1', 'tjInsId1', '01/01', '500', '300', '400'), ('2', 'tjInsId2', '02/01', '400', '600', '700'), ('3', 'tjInsId3', '03/01', '100', '400', '200'), ('4', 'tjInsId4', '04/01', '700', '500', '300'), ('5', 'tjInsId5', '05/01', '900', '300', '800'), ('6', 'tjInsId1', '06/01', '800', '600', '100'), ('7', 'tjInsId1', '07/01', '700', '500', '200'), ('8', 'c640ae22c3f947f584b5a27aa43869bc', '01/01', '500', '300', '400'), ('9', 'c640ae22c3f947f584b5a27aa43869bc', '02/01', '400', '600', '700'), ('10', 'c640ae22c3f947f584b5a27aa43869bc', '03/01', '100', '400', '200'), ('11', 'c640ae22c3f947f584b5a27aa43869bc', '04/01', '700', '500', '300'), ('12', 'c640ae22c3f947f584b5a27aa43869bc', '05/01', '900', '300', '800'), ('13', 'c640ae22c3f947f584b5a27aa43869bc', '06/01', '800', '600', '100'), ('14', 'c640ae22c3f947f584b5a27aa43869bc', '07/01', '700', '500', '200'), ('15', 'd341e1746b004909b218fdfc3af5c7ca', '01/01', '500', '300', '400'), ('16', 'd341e1746b004909b218fdfc3af5c7ca', '02/01', '400', '600', '700'), ('17', 'd341e1746b004909b218fdfc3af5c7ca', '03/01', '100', '400', '200'), ('18', 'd341e1746b004909b218fdfc3af5c7ca', '04/01', '700', '500', '300'), ('19', 'd341e1746b004909b218fdfc3af5c7ca', '05/01', '900', '300', '800'), ('20', 'd341e1746b004909b218fdfc3af5c7ca', '06/01', '800', '600', '100'), ('21', 'd341e1746b004909b218fdfc3af5c7ca', '07/01', '100', '100', '100'), ('22', '00c81b87abe6454db03fe68d95c2c7bd', '01', '300', '300', '300'), ('23', '00c81b87abe6454db03fe68d95c2c7bd', '02', '300', '300', '300'), ('24', '00c81b87abe6454db03fe68d95c2c7bd', '03', '300', '300', '300');
COMMIT;

-- ----------------------------
--  Table structure for `paizan_num_tj`
-- ----------------------------
DROP TABLE IF EXISTS `paizan_num_tj`;
CREATE TABLE `paizan_num_tj` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `tj_ins_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '统计实例标识',
  `area_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '区域标识',
  `area_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '区域名称',
  `yuji_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '淤积数',
  `posun_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '破损数',
  `cuowei_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '错位数',
  `duse_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '堵塞数',
  `yuji_no_begin_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '淤积未开始数',
  `yuji_no_finish_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '淤积未完成数',
  `yuji_finish_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '淤积已完成数',
  `posun_no_begin_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '破损未开始数',
  `posun_no_finish_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '破损未完成数',
  `posun_finish_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '破损已完成数',
  `cuowei_no_begin_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '错位未开始数',
  `cuowei_no_finish_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '错位未完成数',
  `cuowei_finish_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '错位已完成数',
  `duse_no_begin_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '堵塞未开始数',
  `duse_no_finish_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '堵塞未完成数',
  `duse_finish_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '堵塞完成数',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='排障数统计';

-- ----------------------------
--  Records of `paizan_num_tj`
-- ----------------------------
BEGIN;
INSERT INTO `paizan_num_tj` VALUES ('1', null, 'area1', '片区一', '70', '40', '60', '20', '100', '200', '150', '160', '200', '210', '220', '230', '300', '10', '110', '120'), ('2', null, 'area2', '片区二', '80', '70', '20', '30', '200', '210', '220', '230', '240', '250', '260', '270', '280', '290', '300', '310'), ('3', null, 'area3', '片区三', '90', '80', '30', '40', '90', '91', '92', '100', '200', '300', '310', '320', '330', '340', '500', '510'), ('4', null, 'area4', '片区四', '95', '85', '40', '45', '50', '60', '70', '80', '90', '100', '110', '120', '130', '140', '150', '160'), ('5', null, 'area5', '片区四', '93', '83', '50', '43', '200', '300', '500', '100', '200', '500', '300', '400', '100', '50', '60', '100'), ('6', null, 'area6', '片区六', '100', '100', '100', '100', '70', '140', '210', '80', '160', '240', '90', '180', '270', '150', '100', '100'), ('7', '9cdf312a54b24aaba31edf9e35f30fba', 'area1', '片区一', '70', '40', '60', '20', '100', '200', '150', '160', '200', '210', '220', '230', '300', '10', '110', '120'), ('8', '9cdf312a54b24aaba31edf9e35f30fba', 'area2', '片区二', '80', '70', '20', '30', '200', '210', '220', '230', '240', '250', '260', '270', '280', '290', '300', '310'), ('9', '9cdf312a54b24aaba31edf9e35f30fba', 'area3', '片区三', '90', '80', '30', '40', '90', '91', '92', '100', '200', '300', '310', '320', '330', '340', '500', '510'), ('10', '9cdf312a54b24aaba31edf9e35f30fba', 'area4', '片区四', '95', '85', '40', '45', '50', '60', '70', '80', '90', '100', '110', '120', '130', '140', '150', '160'), ('11', '9cdf312a54b24aaba31edf9e35f30fba', 'area5', '片区四', '93', '83', '50', '43', '200', '300', '500', '100', '200', '500', '300', '400', '100', '50', '60', '100'), ('12', '9cdf312a54b24aaba31edf9e35f30fba', 'area6', '片区六', '100', '100', '100', '100', '70', '140', '210', '80', '160', '240', '90', '180', '270', '150', '100', '100'), ('13', 'cf0b3000a4c94dcbb6a60068b6b90017', 'area1', '片区一', '70', '40', '60', '20', '100', '200', '150', '160', '200', '210', '220', '230', '300', '10', '110', '120'), ('14', 'cf0b3000a4c94dcbb6a60068b6b90017', 'area2', '片区二', '80', '70', '20', '30', '200', '210', '220', '230', '240', '250', '260', '270', '280', '290', '300', '310'), ('15', 'cf0b3000a4c94dcbb6a60068b6b90017', 'area3', '片区三', '90', '80', '30', '40', '90', '91', '92', '100', '200', '300', '310', '320', '330', '340', '500', '510'), ('16', 'cf0b3000a4c94dcbb6a60068b6b90017', 'area4', '片区四', '95', '85', '40', '45', '50', '60', '70', '80', '90', '100', '110', '120', '130', '140', '150', '160'), ('17', 'cf0b3000a4c94dcbb6a60068b6b90017', 'area5', '片区四', '93', '83', '50', '43', '200', '300', '500', '100', '200', '500', '300', '400', '100', '50', '60', '100'), ('18', 'cf0b3000a4c94dcbb6a60068b6b90017', 'area6', '片区六', '100', '100', '100', '100', '70', '140', '210', '80', '160', '240', '90', '180', '270', '150', '100', '101'), ('19', '4a00d6ee26334a809f9fce97ff3f9abc', '1', '片区一', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70'), ('20', '4a00d6ee26334a809f9fce97ff3f9abc', '2', '片区二', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70'), ('21', '4a00d6ee26334a809f9fce97ff3f9abc', '3', '片区三', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70'), ('22', '4a00d6ee26334a809f9fce97ff3f9abc', '4', '片区四', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70'), ('23', '4a00d6ee26334a809f9fce97ff3f9abc', '5', '片区五', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70'), ('24', '4a00d6ee26334a809f9fce97ff3f9abc', '6', '片区六', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70');
COMMIT;

-- ----------------------------
--  Table structure for `pipe_bo_num_tj`
-- ----------------------------
DROP TABLE IF EXISTS `pipe_bo_num_tj`;
CREATE TABLE `pipe_bo_num_tj` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `tj_ins_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '统计实例标识',
  `area_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '区域标识',
  `area_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '区域名称',
  `pipe_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '管道总数',
  `guanjin_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '管井总数',
  `sensor_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '传感器总数',
  `benzan_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '泵站总数',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='管网业务对象数量统计';

-- ----------------------------
--  Records of `pipe_bo_num_tj`
-- ----------------------------
BEGIN;
INSERT INTO `pipe_bo_num_tj` VALUES ('1', null, '1', '六合区', '300', '250', '400', '100'), ('2', null, '2', '浦口区', '400', '200', '450', '110'), ('3', null, '3', '鼓楼区', '500', '300', '460', '120'), ('4', null, '4', '玄武区', '600', '350', '470', '130'), ('5', null, '5', '栖霞区', '700', '400', '480', '140'), ('6', null, '6', '建邺区', '800', '450', '490', '150'), ('7', null, '7', '秦淮区', '900', '500', '500', '160'), ('8', null, '8', '雨花台区', '950', '550', '510', '170'), ('9', null, '9', '江辽区', '850', '600', '520', '180'), ('10', null, '10', '溧水区', '750', '650', '530', '190'), ('11', null, '11', '高淳区', '650', '700', '540', '200'), ('12', 'f246c44ebd89428ab269438a58d00322', '1', '六合区', '300', '250', '400', '100'), ('13', 'f246c44ebd89428ab269438a58d00322', '2', '浦口区', '400', '200', '450', '110'), ('14', 'f246c44ebd89428ab269438a58d00322', '3', '鼓楼区', '500', '300', '460', '120'), ('15', 'f246c44ebd89428ab269438a58d00322', '4', '玄武区', '600', '350', '470', '130'), ('16', 'f246c44ebd89428ab269438a58d00322', '5', '栖霞区', '700', '400', '480', '140'), ('17', 'f246c44ebd89428ab269438a58d00322', '6', '建邺区', '800', '450', '490', '150'), ('18', 'f246c44ebd89428ab269438a58d00322', '7', '秦淮区', '900', '500', '500', '160'), ('19', 'f246c44ebd89428ab269438a58d00322', '8', '雨花台区', '950', '550', '510', '170'), ('20', 'f246c44ebd89428ab269438a58d00322', '9', '江辽区', '850', '600', '520', '180'), ('21', 'f246c44ebd89428ab269438a58d00322', '10', '溧水区', '750', '650', '530', '190'), ('22', 'f246c44ebd89428ab269438a58d00322', '11', '高淳区', '650', '700', '540', '200'), ('23', 'ba05394e16eb4740b578465b4448e481', '1', '六合区', '300', '250', '400', '101'), ('24', 'ba05394e16eb4740b578465b4448e481', '2', '浦口区', '400', '200', '450', '110'), ('25', 'ba05394e16eb4740b578465b4448e481', '3', '鼓楼区', '500', '300', '460', '120'), ('26', 'ba05394e16eb4740b578465b4448e481', '4', '玄武区', '600', '350', '470', '130'), ('27', 'ba05394e16eb4740b578465b4448e481', '5', '栖霞区', '700', '400', '480', '140'), ('28', 'ba05394e16eb4740b578465b4448e481', '6', '建邺区', '800', '450', '490', '150'), ('29', 'ba05394e16eb4740b578465b4448e481', '7', '秦淮区', '900', '500', '500', '160'), ('30', 'ba05394e16eb4740b578465b4448e481', '8', '雨花台区', '950', '550', '510', '170'), ('31', 'ba05394e16eb4740b578465b4448e481', '9', '江辽区', '850', '600', '520', '180'), ('32', 'ba05394e16eb4740b578465b4448e481', '10', '溧水区', '750', '650', '530', '190'), ('33', 'ba05394e16eb4740b578465b4448e481', '11', '高淳区', '650', '700', '540', '200');
COMMIT;

-- ----------------------------
--  Table structure for `pipe_health_tj`
-- ----------------------------
DROP TABLE IF EXISTS `pipe_health_tj`;
CREATE TABLE `pipe_health_tj` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `tj_ins_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '统计实例标识',
  `exception_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '异常总数',
  `yuji_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '淤积数',
  `posun_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '破损数',
  `cuowei_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '错位数',
  `duse_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '堵塞数',
  `normal_zb` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '正常数占比',
  `alarm_zb` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '预警数占比',
  `warn_zb` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '告警数占比',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='管道健康情况统计';

-- ----------------------------
--  Records of `pipe_health_tj`
-- ----------------------------
BEGIN;
INSERT INTO `pipe_health_tj` VALUES ('1', null, '10', '25', '21', '210', '22', '20', '20', '20'), ('2', 'd03df4a08917465ea190cb471b44afd8', '10', '25', '21', '210', '22', '20', '20', '20'), ('3', 'fd4699d2992e4c05890caf38b9de87c0', '10', '23', '23', '213', '23', '23', '23', '23'), ('4', 'f8b3e6ffbdc94c08ad4304aac21d5103', '13', '23', '23', '213', '23', '23', '23', '23'), ('5', 'c2aeecd78828455388ae1c3bef8dfa21', '14', '24', '23', '213', '23', '23', '23', '23'), ('6', '113a96b393cb48478a6406f105131ea8', '20', '20', '20', '20', '20', '20', '20', '20'), ('7', '029413409aa248f78a52de0bd631b35e', '25', '25', '25', '25', '25', '25', '25', '25'), ('8', '67db688e270b4ea1800493cb76a01309', '10', '10', '10', '10', '10', '20', '20', '20'), ('9', 'b96f64cee59845d09f68ac6585ad481a', '20', '10', '10', '10', '10', '20', '20', '20');
COMMIT;

-- ----------------------------
--  Table structure for `pipe_length_tj`
-- ----------------------------
DROP TABLE IF EXISTS `pipe_length_tj`;
CREATE TABLE `pipe_length_tj` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `tj_ins_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '统计实例标识',
  `pipe_lengh` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '管道总长度',
  `main_lengh` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '主干管总长度',
  `sub_lengh` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '支干网总长度',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='管道长度统计';

-- ----------------------------
--  Records of `pipe_length_tj`
-- ----------------------------
BEGIN;
INSERT INTO `pipe_length_tj` VALUES ('1', null, null, null, null), ('2', 'd026cb8c8e624b63abe30c25855767eb', '100', '200', '300'), ('3', 'ef22f5e6b01c4630a4377b06890304eb', '300', '300', '500'), ('4', 'ba67a33789ca48acb0591b46ee9a73e3', '320', '300', '400'), ('5', '5122dfb8173d4cf88e6090395cb3de50', '200', '100', '300'), ('6', '726138f73926497e8991e8397391264e', '400', '300', '600'), ('7', '2a71021a419643caa29302c959579859', '500', '400', '700');
COMMIT;

-- ----------------------------
--  Table structure for `pipe_mate_tj`
-- ----------------------------
DROP TABLE IF EXISTS `pipe_mate_tj`;
CREATE TABLE `pipe_mate_tj` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `tj_ins_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '统计实例标识',
  `pe_zb` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'PE材质占比',
  `bxg_zb` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '不锈钢材质占比',
  `tie_zb` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '铁管材质占比',
  `suini_zb` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '水泥材质占比',
  `other_zb` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '其它材质占比',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='管道材质占比统计';

-- ----------------------------
--  Records of `pipe_mate_tj`
-- ----------------------------
BEGIN;
INSERT INTO `pipe_mate_tj` VALUES ('1', null, '200', '200', '200', '200', '200'), ('2', '1f60ece84f9440889a06904ef580637d', '201', '201', '201', '201', '201'), ('3', 'cf930971688643c095028eb9a5ebe1c2', '202', '202', '202', '202', '202'), ('4', 'a96b18021ad34258b67830526e552087', '20', '20', '20', '20', '20'), ('5', 'd9489b412d8c4723a806635e239f6459', '10', '10', '10', '10', '10');
COMMIT;

-- ----------------------------
--  Table structure for `pipe_years_tj`
-- ----------------------------
DROP TABLE IF EXISTS `pipe_years_tj`;
CREATE TABLE `pipe_years_tj` (
  `id` int NOT NULL AUTO_INCREMENT,
  `one_two_year` varchar(255) DEFAULT NULL COMMENT '1-2年',
  `thre_five_year` varchar(255) DEFAULT NULL COMMENT '3-5年',
  `five_ten_year` varchar(255) DEFAULT NULL COMMENT '5-10年',
  `dayu_ten_year` varchar(255) DEFAULT NULL COMMENT '10年以上',
  `tj_ins_id` varchar(255) DEFAULT NULL COMMENT '统计主题id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='管龄表';

-- ----------------------------
--  Records of `pipe_years_tj`
-- ----------------------------
BEGIN;
INSERT INTO `pipe_years_tj` VALUES ('1', '10', '10', '10', '10', null), ('2', '11', '11', '11', '11', '86815d33e6124ecfa00668f2dc04c5c8'), ('3', '12', '12', '10', '10', '576a872060954e889703c32a0712b4d3'), ('4', '15', '15', '15', '15', 'fa62480009894b5a8a7dfa8206ee946d'), ('5', null, null, null, null, '291439b7942c4f9b8aeec945e2d77bc3'), ('6', '10', '10', '10', '10', '7e1e7be207524384a6677afa48a7771b');
COMMIT;

-- ----------------------------
--  Table structure for `pipe_zijin_tj`
-- ----------------------------
DROP TABLE IF EXISTS `pipe_zijin_tj`;
CREATE TABLE `pipe_zijin_tj` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `tj_ins_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '统计实例标识',
  `xiaoyu_three_zb` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '小于300占比',
  `three_five_zb` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '300至500占比',
  `five_ten_zb` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '500至1000占比',
  `dayu_ten_zb` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '1000以上占比',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='管道直径占比统计';

-- ----------------------------
--  Records of `pipe_zijin_tj`
-- ----------------------------
BEGIN;
INSERT INTO `pipe_zijin_tj` VALUES ('1', null, '300', '300', '100', '100'), ('2', '38a452ff2cee410092f2b6286fa99402', '400', '400', '200', '200'), ('3', '6dcd3d5a1ec84483a775f68ab6d258c6', '600', '600', '200', '200'), ('4', '788c4c7e7a66462ba5ce1797fa74097e', '600', '600', '600', '600');
COMMIT;

-- ----------------------------
--  Table structure for `prev_day_suiwei`
-- ----------------------------
DROP TABLE IF EXISTS `prev_day_suiwei`;
CREATE TABLE `prev_day_suiwei` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `tj_ins_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '统计实例标识',
  `fd_zb` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '峰段占比',
  `pd_zb` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '平段占比',
  `gd_zb` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '谷段占比',
  `fd_vals` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '总体水位阈值定义-峰段区间',
  `pd_vals` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '总体水位阈值定义-平段区间',
  `gd_vals` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '总体水位阈值定义-谷段区间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='昨日总体水位';

-- ----------------------------
--  Records of `prev_day_suiwei`
-- ----------------------------
BEGIN;
INSERT INTO `prev_day_suiwei` VALUES ('1', 'string', 'string', 'string', 'string', '200', '20', '20'), ('2', 'f0617232146e40b983473d200726578e', 'string', 'string', 'string', '100', '100', '100'), ('3', 'e49d3c35e2ca40538cf9e12006cc861b', 'string', 'string', 'string', '200', '100', '100'), ('4', '9d4ec90126e04f4b8e0b44f2b4985b42', 'string', 'string', 'string', '200', '300', '300'), ('5', '02cb0e4a408e433e9362765cc9f0b880', '0.1', '0.1', '0.1', '200', '200', '200');
COMMIT;

-- ----------------------------
--  Table structure for `sensor`
-- ----------------------------
DROP TABLE IF EXISTS `sensor`;
CREATE TABLE `sensor` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `dev_big_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '1' COMMENT '设备大类 1-水质，2-水量',
  `dev_big_type_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '设备大类名称',
  `dev_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '1' COMMENT '设备类型 1-电子水尺，2-窑井水位仪，3-雨量计，4-智能井盖，5-CH2，6-H2S，7-CO，8-PH',
  `dev_type_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '设备类型名称',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '设备名称',
  `gis_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '地理位置名称',
  `gis_jindu` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '地理位置经度',
  `gis_weidu` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '地理位置纬度',
  `state` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '设备状态 warn-告警， alarm-预警，空-正常',
  `state_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '设备状态名称',
  `xinhao` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '1' COMMENT '信号情况 1-正常，2-差',
  `xinhao_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '信号情况名称',
  `tiaosi` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '2' COMMENT '调试状态 1-是 ，2-否',
  `tiaosi_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '调试状态名称',
  `build_time` datetime DEFAULT NULL COMMENT '安装时间',
  `caosenbo_suiwei` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '0' COMMENT '超声波水位',
  `yali_suiwei` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '0' COMMENT '压力水位',
  `hight_for_bottom` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '0' COMMENT '离水底高度',
  `senyu_dianlian` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '1' COMMENT '剩余电量',
  `val_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '值类型名称',
  `val_type_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '值单位名称',
  `alarm_limit_val` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '0' COMMENT '预警阀值',
  `warn_limit_val` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '0' COMMENT '告警阀值',
  `newest_val` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '最新值',
  `newest_report_time` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '最新通信时间',
  `newest_report_id` int DEFAULT NULL COMMENT '最新通讯标识（预留）',
  `alert_all_num` int DEFAULT '0' COMMENT '警告总次数',
  `aleam_num` int DEFAULT '0' COMMENT '预警总次数',
  `warn_num` int DEFAULT '0' COMMENT '告警总次数',
  `report_num` int DEFAULT '0' COMMENT '通信总次数',
  `report_num_today` int DEFAULT '0' COMMENT '今日通讯值',
  `min_val` float(10,2) DEFAULT '0.00' COMMENT '历史最小值',
  `max_val` float(10,2) DEFAULT '0.00' COMMENT '历史最大值',
  `ave_val` float(10,2) DEFAULT '0.00' COMMENT '历史平均值',
  `this_min_val` float(10,2) DEFAULT '0.00' COMMENT '当天最小值',
  `prev_min_val` float(10,2) DEFAULT '0.00' COMMENT '上一日最小值',
  `this_min_chg_qusi` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '当天最小值变化趋势',
  `prev_min_chg_qusi` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '上一日最小值变化趋势',
  `this_min_chg_lv` float(10,2) DEFAULT '0.00' COMMENT '当天最小值变化率',
  `this_max_val` float(10,2) DEFAULT '0.00' COMMENT '当天最大值',
  `prev_max_val` float(10,2) DEFAULT '0.00' COMMENT '上一日最大值',
  `this_max_chg_qusi` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '当天最大值变化趋势',
  `prev_max_chg_qusi` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '上一日最大值变化趋势',
  `this_max_chg_lv` float(10,2) DEFAULT '0.00' COMMENT '当天最大值变化率',
  `this_ave_val` float(10,2) DEFAULT '0.00' COMMENT '当天平均值',
  `prev_ave_val` float(10,2) DEFAULT '0.00' COMMENT '上一日平均值',
  `this_ave_chg_qusi` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '当天平均值变化趋势',
  `prev_ave_chg_qusi` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '上一日平均值变化趋势',
  `this_ave_chg_lv` float(10,2) DEFAULT '0.00' COMMENT '当天平均值变化率',
  `gen_time` datetime DEFAULT NULL COMMENT '创建时间',
  `rec_state` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '记录状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='传感器';

-- ----------------------------
--  Records of `sensor`
-- ----------------------------
BEGIN;
INSERT INTO `sensor` VALUES ('1', '1', '水量', '1', '电子水尺', '0001', '南京某区某街道', '118.22', '33.14', 'warn', '告警', '1', '正常', '1', '是', '2020-11-15 22:57:13', '20', '20', '20', '0.1', 'string', 'string', '300', '400', '300', '2020-12-14 15:15:59', '244', '0', '0', '0', '3', '2', '300.00', '300.00', '300.00', '300.00', '300.00', '不变', null, '0.00', '300.00', '300.00', '不变', null, '0.00', '300.00', '300.00', '不变', null, '0.00', '2020-12-14 15:15:59', null), ('2', '1', '水质', '5', 'CH2', '0036', '地理位置名称', '119.14', '32.37', 'warn', null, null, null, null, 'hedf', '2020-11-15 22:57:18', '40', '600', null, '1', null, null, '400', '500', '500', '2020-11-20T10:37:49.453', '189', '6330', '6235', '6437', '6351', '3', '100.00', '1000.00', '674.91', '500.00', '100.00', '上升', '下降', '4.00', '1000.00', '1000.00', '不变', '下降', '0.00', '700.00', '520.00', '上升', '634', '0.35', '2020-11-20 10:37:49', ''), ('3', '1', '水质', '6', 'H2S', '0035', '地理位置名称', '119.34', '32.37', null, null, null, null, null, 'hedf', '2020-11-15 22:57:23', '40', '600', null, '1', null, null, '800', '900', '234', '2020-11-09 09:26:13', '6342', '6324', '6234', '6432', '6342', '0', '2364.00', '0.00', '634.00', '65434.00', '7865.00', '754', '865', '87456.00', '856.00', '86.00', '4576', '7654', '0.00', '12.00', '0.00', '345', '634', '234.00', '2020-11-04 17:47:26', '3464'), ('4', '1', '水质', '7', 'CO', '0035', '地理位置名称', '119.44', '32.47', null, null, null, null, null, 'hedf', '2020-11-15 22:57:28', '40', '600', null, '1', null, null, '800', '900', '234', '2020-11-09 09:26:13', '6342', '6324', '6234', '6432', '6342', '0', '2364.00', '0.00', '634.00', '65434.00', '7865.00', '754', '865', '87456.00', '856.00', '86.00', '4576', '7654', '0.00', '12.00', '0.00', '345', '634', '234.00', '2020-11-04 17:47:26', '3464'), ('5', '2', '水量', '2', '窑井水位仪', '0037', '地理位置名称', '119.25', '32.43', null, null, null, null, null, 'hedf', '2020-11-15 22:57:32', '40', '600', null, '1', null, null, '800', '900', '234', '2020-11-09 09:26:13', '6342', '6324', '6234', '6432', '6342', '0', '2364.00', '0.00', '634.00', '65434.00', '7865.00', '754', '865', '87456.00', '856.00', '86.00', '4576', '7654', '0.00', '12.00', '0.00', '345', '634', '234.00', '2020-11-04 17:47:26', '3464'), ('6', '2', '水量', '2', '窑井水位仪', '0038', '地理位置名称', '119.14', '32.47', 'warn', null, null, null, null, 'hedf', '2020-11-15 22:57:36', '40', '600', null, '1', null, null, '800', '900', '500', '2020-11-20T10:38:10.516', '190', '6328', '6234', '6436', '6350', '1', '100.00', '3333.00', '2442.74', '500.00', '100.00', '上升', '下降', '4.00', '500.00', '1000.00', '下降', '下降', '-0.50', '500.00', '425.00', '上升', '634', '0.18', '2020-11-20 10:38:10', ''), ('7', '1', '水质', '8', 'PH', '0035', '地理位置名称', '119.28', '32.42', null, null, null, null, null, 'hedf', '2020-11-15 22:57:40', '40', '600', null, '1', null, null, '800', '900', '900', '2020-11-19 16:33:52', '168', '6325', '6235', '6432', '6344', '2', '800.00', '900.00', '634.07', '800.00', '65434.00', '下降', '754', '-0.99', '900.00', '856.00', '上升', '4576', '0.05', '850.00', '12.00', '上升', '634', '69.83', '2020-11-19 16:33:52', ''), ('8', '2', '水量', '3', '雨量计', '0039', '地理位置名称', '119.22', '33.14', 'warn', null, null, null, null, 'hedf', '2020-11-15 22:57:45', '24', '643', null, '1', null, null, '400', '500', '200', '2020-12-07 09:46:04', '229', '6325', '0', '1', '1', '1', '100.00', '800.00', '200.00', '200.00', '300.00', '下降', '下降', '-0.80', '200.00', '600.00', '下降', '下降', '-0.60', '200.00', '450.00', '下降', null, '-0.60', '2020-12-07 09:46:04', '');
COMMIT;

-- ----------------------------
--  Table structure for `sensor_img`
-- ----------------------------
DROP TABLE IF EXISTS `sensor_img`;
CREATE TABLE `sensor_img` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `sensor_id` int DEFAULT NULL COMMENT '传感器标识',
  `img_xinzi` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '图片性质',
  `img_xinzi_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '图片性质名称',
  `img_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '图片URL',
  PRIMARY KEY (`id`),
  KEY `FKg46baissh5houat2u9d2sid33` (`sensor_id`),
  CONSTRAINT `FKg46baissh5houat2u9d2sid33` FOREIGN KEY (`sensor_id`) REFERENCES `sensor` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='现场图片';

-- ----------------------------
--  Records of `sensor_img`
-- ----------------------------
BEGIN;
INSERT INTO `sensor_img` VALUES ('17', null, null, null, 'http://test.com/img2'), ('18', null, null, null, 'http://test.com/img2'), ('19', null, null, null, 'http://test.com/img2'), ('20', '2', null, null, 'http://test.com/img3'), ('21', '2', null, null, 'http://test.com/img3');
COMMIT;

-- ----------------------------
--  Table structure for `sensor_num_tj`
-- ----------------------------
DROP TABLE IF EXISTS `sensor_num_tj`;
CREATE TABLE `sensor_num_tj` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `tj_ins_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '统计实例标识',
  `suiwei_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '管井水位仪数量',
  `liulian_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '管道流量仪数量',
  `ch2_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'CH2探测仪数量',
  `co_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'CO探测仪数量',
  `h2s_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'H2S探测仪数量',
  `ph_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'PH探测仪数量',
  `robot_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '巡检机器人数量',
  `wenduji_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '电子温度计数量',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='传感器数量统计';

-- ----------------------------
--  Records of `sensor_num_tj`
-- ----------------------------
BEGIN;
INSERT INTO `sensor_num_tj` VALUES ('1', null, '12', '12', '12', '12', '12', '12', '12', '12'), ('2', '74fbdb24333342e9bdad0aa3fced4591', '13', '13', '13', '13', '13', '13', '13', '13'), ('3', '6e3211b103564394ab298de8ab878bc4', '14', '14', '14', '14', '14', '14', '14', '14'), ('4', 'c8c2811289d8417c8f898517bbe8d1a4', '15', '15', '15', '15', '15', '15', '15', '15'), ('5', 'b8a9c852835f4f7dbc51bc74ffe5645d', '16', '16', '12', '12', '12', '12', '12', '12'), ('6', 'eefa8c8e7492443f9aa0fe2372a67584', '18', '18', '18', '18', '18', '18', '18', '18'), ('7', '862ee62395dd45f79c506ec7ec996119', '19', '19', '19', '19', '19', '19', '19', '19'), ('8', 'cbedd221ee96486fb062be79660ec917', '20', '20', '20', '20', '20', '20', '20', '20'), ('9', '53cc3346ea0a4357b82e4c175cbc144c', '21', '21', '21', '21', '21', '21', '21', '21'), ('10', 'fea42c2ef6104000be3e373ead0bba56', '25', '25', '25', '25', '25', '25', '25', '25'), ('11', '8c0ac01e0ff7418a9fb033ee7f398dfb', '20', '20', '20', '20', '20', '120', '20', '20');
COMMIT;

-- ----------------------------
--  Table structure for `sensor_report`
-- ----------------------------
DROP TABLE IF EXISTS `sensor_report`;
CREATE TABLE `sensor_report` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `sensor_id` int DEFAULT NULL COMMENT '传感器标识',
  `report_val` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '通信值',
  `gen_warn` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '是否形成告警',
  `warn_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '告警标识',
  `gen_time` datetime DEFAULT NULL COMMENT '创建时间',
  `rec_state` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '记录状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=245 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='传感器通信记录';

-- ----------------------------
--  Records of `sensor_report`
-- ----------------------------
BEGIN;
INSERT INTO `sensor_report` VALUES ('124', '1', '600', '', '', '2020-11-16 15:32:16', ''), ('125', '1', '300', '', '', '2020-11-16 16:55:06', ''), ('126', '1', '700', '', '', '2020-11-17 16:58:25', ''), ('127', '1', '800', '', '', '2020-11-17 17:10:32', ''), ('128', '1', '1000', '', '', '2020-11-17 17:12:39', ''), ('129', '1', '500', '', '', '2020-11-17 17:15:34', ''), ('130', '2', '2000', '', '', '2020-11-17 17:24:16', ''), ('131', '1', '300', 'string', 'string', '2020-11-17 21:48:54', 'test'), ('132', '1', '1000', 'string', 'string', '2020-11-17 21:53:26', 'test'), ('133', '1', '1100', 'string', 'string', '2020-11-17 21:57:25', 'test'), ('134', '1', '1100', 'string', 'string', '2020-11-17 22:22:20', 'test'), ('135', '6', '2000', '', '', '2020-11-18 11:18:45', ''), ('136', '1', '1000', '', '', '2020-11-18 11:20:31', ''), ('137', '1', '1000', '', '', '2020-11-18 11:22:59', ''), ('138', '1', '1000', '', '', '2020-11-18 11:25:17', ''), ('139', '6', '2000', '', '', '2020-11-18 11:25:58', ''), ('140', '6', '3333', '', '', '2020-11-18 11:38:52', ''), ('141', '1', '900', '', '', '2020-11-18 22:22:48', ''), ('142', '1', '900', '', '', '2020-11-18 22:32:01', ''), ('143', '1', '900', '', '', '2020-11-18 22:33:02', ''), ('144', '1', '200', '', '', '2020-11-18 22:33:48', ''), ('145', '1', '500', '', '', '2020-11-19 11:02:29', ''), ('146', '1', '400', '', '', '2020-11-19 11:05:11', ''), ('147', '1', '1000', '', '', '2020-11-19 12:25:06', ''), ('148', '1', '950', '', '', '2020-11-19 12:27:45', ''), ('149', '1', '980', '', '', '2020-11-19 12:28:03', ''), ('150', '1', '980', '', '', '2020-11-19 12:28:41', ''), ('151', '1', '980', '', '', '2020-11-19 12:30:02', ''), ('152', '1', '1000', '', '', '2020-11-19 16:09:51', ''), ('153', '1', '1000', '', '', '2020-11-19 16:20:18', ''), ('154', '1', '1000', '', '', '2020-11-19 16:21:26', ''), ('155', '1', '1000', '', '', '2020-11-19 16:22:07', ''), ('156', '1', '1000', '', '', '2020-11-19 16:22:53', ''), ('157', '1', '1000', '', '', '2020-11-19 16:24:40', ''), ('158', '1', '800', '', '', '2020-11-19 16:25:53', ''), ('159', '1', '800', '', '', '2020-11-19 16:30:14', ''), ('160', '1', '880', '', '', '2020-11-19 16:30:49', ''), ('161', '2', '880', '', '', '2020-11-19 16:31:12', ''), ('162', '2', '100', '', '', '2020-11-19 16:31:33', ''), ('163', '2', '100', '', '', '2020-11-19 16:32:08', ''), ('164', '6', '100', '', '', '2020-11-19 16:32:37', ''), ('165', '6', '100', '', '', '2020-11-19 16:33:08', ''), ('166', '6', '500', '', '', '2020-11-19 16:33:26', ''), ('167', '7', '800', '', '', '2020-11-19 16:33:39', ''), ('168', '7', '900', '', '', '2020-11-19 16:33:52', ''), ('169', '1', '900', '', '', '2020-11-19 16:39:28', ''), ('170', '6', '1000', '', '', '2020-11-19 16:39:52', ''), ('171', '2', '1000', '', '', '2020-11-19 16:40:10', ''), ('172', '1', '1000', '', '', '2020-11-19 16:40:20', ''), ('173', '1', '900', '', '', '2020-11-19 16:46:31', ''), ('174', '1', '800', '', '', '2020-11-19 19:51:07', ''), ('175', '1', '900', '', '', '2020-11-19 19:51:35', ''), ('176', '1', '900', '', '', '2020-11-19 19:52:41', ''), ('177', '1', '700', '', '', '2020-11-20 09:58:42', ''), ('178', '1', '1000', '', '', '2020-11-20 10:13:39', ''), ('179', '1', '1000', '', '', '2020-11-20 10:13:40', ''), ('180', '1', '1000', '', '', '2020-11-20 10:19:55', ''), ('181', '1', '500', '', '', '2020-11-20 10:28:01', ''), ('182', '1', '800', '', '', '2020-11-20 10:29:13', ''), ('183', '1', '900', '', '', '2020-11-20 10:31:24', ''), ('184', '1', '600', '', '', '2020-11-20 10:31:59', ''), ('185', '1', '800', '', '', '2020-11-20 10:36:50', ''), ('186', '1', '1000', '', '', '2020-11-20 10:37:06', ''), ('187', '2', '1000', '', '', '2020-11-20 10:37:19', ''), ('188', '2', '600', '', '', '2020-11-20 10:37:37', ''), ('189', '2', '500', '', '', '2020-11-20 10:37:49', ''), ('190', '6', '500', '', '', '2020-11-20 10:38:10', ''), ('191', '1', '800', '', '', '2020-11-20 11:09:50', ''), ('192', '1', '1100', '', '', '2020-11-20 11:10:14', ''), ('193', '1', '401', '', '', '2020-11-28 11:28:57', ''), ('194', '1', '501', '', '', '2020-11-28 11:29:41', ''), ('195', '1', '301', '', '', '2020-11-28 11:30:07', ''), ('196', '1', '503', '', '', '2020-11-28 11:44:36', ''), ('197', '1', '700', '', '', '2020-12-01 20:11:10', ''), ('198', '1', '800', '', '', '2020-12-01 20:11:57', ''), ('199', '1', '800', '', '', '2020-12-05 20:13:27', ''), ('200', '1', '300', '', '', '2020-12-05 20:13:40', ''), ('201', '1', '600', '', '', '2020-12-06 13:24:06', ''), ('202', '1', '300', '', '', '2020-12-06 17:26:05', ''), ('203', '1', '400', '', '', '2020-12-06 17:34:34', ''), ('204', '1', '200', '', '', '2020-12-06 18:43:49', ''), ('205', '1', '600', '', '', '2020-12-06 18:51:53', ''), ('206', '1', '1000', '', '', '2020-12-06 18:52:24', ''), ('207', '1', '300', '', '', '2020-12-06 19:38:41', ''), ('208', '1', '200', '', '', '2020-12-06 19:38:51', ''), ('209', '1', '800', '', '', '2020-12-06 19:45:24', ''), ('210', '1', '300', '', '', '2020-12-06 19:47:08', ''), ('211', '1', '800', '', '', '2020-12-06 20:17:24', ''), ('212', '1', '400', '', '', '2020-12-06 20:18:53', ''), ('213', '1', '200', '', '', '2020-12-06 20:19:57', ''), ('214', '1', '200', '', '', '2020-12-06 20:20:17', ''), ('215', '1', '400', '', '', '2020-12-06 22:04:13', ''), ('216', '1', '1000', '', '', '2020-12-06 22:05:24', ''), ('217', '1', '200', '', '', '2020-12-06 22:06:12', ''), ('218', '1', '400', '', '', '2020-12-06 22:13:52', ''), ('219', '1', '500', '', '', '2020-12-06 22:24:45', ''), ('220', '1', '600', '', '', '2020-12-06 22:25:33', ''), ('221', '1', '600', '', '', '2020-12-06 22:53:36', ''), ('222', '1', '1000', '', '', '2020-12-06 22:53:51', ''), ('223', '1', '1000', '', '', '2020-12-06 23:12:34', ''), ('224', '1', '800', '', '', '2020-12-06 23:13:29', ''), ('225', '1', '800', '', '', '2020-12-06 23:18:47', ''), ('226', '1', '800', '', '', '2020-12-06 23:19:30', ''), ('227', '1', '800', '', '', '2020-12-06 23:23:41', ''), ('228', '1', '100', '', '', '2020-12-06 23:40:53', ''), ('230', '1', '400', '', '', '2020-12-07 10:17:43', ''), ('231', '8', '200', '', '', '2020-12-07 09:46:04', ''), ('232', '1', '600', '', '', '2020-12-07 14:26:46', ''), ('233', '1', '800', '', '', '2020-12-07 14:28:04', ''), ('234', '1', '450', '', '', '2020-12-07 14:32:21', ''), ('235', '1', '490', '', '', '2020-12-07 14:40:41', ''), ('236', '1', '700', '', '', '2020-12-07 17:02:31', ''), ('237', '1', '600', '', '', '2020-12-07 17:14:26', ''), ('238', '1', '600', '', '', '2020-12-09 20:16:15', ''), ('239', '1', '600', '', '', '2020-12-09 20:48:55', ''), ('240', '1', '300', null, null, '2020-12-11 11:53:25', null), ('241', '1', '300', null, null, '2020-12-13 10:34:27', null), ('242', '1', '300', null, null, '2020-12-13 11:02:12', null), ('243', '1', '300', null, null, '2020-12-14 09:39:40', null), ('244', '1', '300', null, null, '2020-12-14 15:15:59', null);
COMMIT;

-- ----------------------------
--  Table structure for `sensor_warn`
-- ----------------------------
DROP TABLE IF EXISTS `sensor_warn`;
CREATE TABLE `sensor_warn` (
  `id` int NOT NULL AUTO_INCREMENT,
  `gen_time` datetime DEFAULT NULL,
  `rec_state` varchar(255) DEFAULT NULL,
  `sensor_id` int DEFAULT NULL,
  `warn_type` varchar(255) DEFAULT NULL COMMENT '警告类型：1-预警，2-告警',
  `warn_val` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKmy835ysv7qc4s12sk7jirh0j8` (`sensor_id`) USING BTREE,
  CONSTRAINT `FKmy835ysv7qc4s12sk7jirh0j8` FOREIGN KEY (`sensor_id`) REFERENCES `sensor` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=128 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `sensor_warn`
-- ----------------------------
BEGIN;
INSERT INTO `sensor_warn` VALUES ('6', '2020-11-08 20:57:50', null, '2', '2', '12'), ('8', '2020-11-08 21:33:42', null, '2', '2', '12'), ('9', '2020-11-08 21:33:54', null, '2', '2', '12'), ('11', '2020-11-09 15:30:55', null, '2', '2', '2134'), ('12', '2020-11-12 10:03:15', '', '2', '2', '700'), ('13', '2020-11-12 10:28:09', '', '2', '2', '800'), ('43', '2020-11-17 16:58:26', '', '1', '1', '700'), ('46', '2020-11-17 17:24:17', '', '2', '2', '2000'), ('51', '2020-11-18 11:18:46', '', '6', '2', '2000'), ('55', '2020-11-18 11:25:58', '', '6', '2', '2000'), ('56', '2020-11-18 11:38:53', '', '6', '2', '3333'), ('78', '2020-11-19 16:31:12', '', '2', '2', '880'), ('80', '2020-11-19 16:39:52', '', '6', '2', '1000'), ('81', '2020-11-19 16:40:11', '', '2', '2', '1000'), ('83', '2020-11-19 16:46:31', '', '1', '1', '900'), ('84', '2020-11-19 19:51:08', '', '1', '1', '800'), ('85', '2020-11-19 19:51:36', '', '1', '1', '900'), ('86', '2020-11-19 19:52:42', '', '1', '1', '900'), ('87', '2020-11-20 09:58:42', '', '1', '1', '700'), ('88', '2020-11-20 10:13:40', '', '1', '1', '1000'), ('89', '2020-11-20 10:13:40', '', '1', '1', '1000'), ('90', '2020-11-20 10:19:56', '', '1', '1', '1000'), ('91', '2020-11-20 10:29:14', '', '1', '2', '800'), ('92', '2020-11-20 10:31:25', '', '1', '2', '900'), ('93', '2020-11-20 10:31:59', '', '1', '2', '600'), ('94', '2020-11-20 10:36:51', '', '1', '2', '800'), ('95', '2020-11-20 10:37:07', '', '1', '2', '1000'), ('96', '2020-11-20 10:37:20', '', '2', '2', '1000'), ('97', '2020-11-20 10:37:37', '', '2', '2', '600'), ('98', '2020-11-20 11:09:50', '', '1', '2', '800'), ('99', '2020-11-20 11:10:15', '', '1', '2', '1100'), ('100', '2020-11-28 11:28:58', '', '1', '1', '401'), ('101', '2020-11-28 11:29:41', '', '1', '2', '501'), ('102', '2020-11-28 11:44:36', '', '1', '2', '503'), ('103', '2020-12-01 20:11:11', '', '1', '2', '700'), ('104', '2020-12-01 20:11:58', '', '1', '2', '800'), ('105', '2020-12-01 20:13:28', '', '1', '2', '800'), ('106', '2020-12-06 17:24:07', '', '1', '2', '600'), ('107', '2020-12-06 18:51:53', '', '1', '2', '600'), ('108', '2020-12-06 18:52:24', '', '1', '2', '1000'), ('109', '2020-12-06 19:45:24', '', '1', '2', '800'), ('110', '2020-12-06 20:17:24', '', '1', '2', '800'), ('111', '2020-12-06 22:05:24', '', '1', '2', '1000'), ('112', '2020-12-06 22:25:33', '', '1', '2', '600'), ('113', '2020-12-06 22:53:36', '', '1', '2', '600'), ('114', '2020-12-06 22:53:51', '', '1', '2', '1000'), ('115', '2020-12-06 23:12:34', '', '1', '2', '1000'), ('116', '2020-12-06 23:13:29', '', '1', '2', '800'), ('117', '2020-12-06 23:18:47', '', '1', '2', '800'), ('118', '2020-12-06 23:19:30', '', '1', '2', '800'), ('119', '2020-12-06 23:23:41', '', '1', '2', '800'), ('120', '2020-12-07 14:26:46', '', '1', '2', '600'), ('121', '2020-12-07 14:28:04', '', '1', '2', '800'), ('122', '2020-12-07 14:32:21', '', '1', '1', '450'), ('123', '2020-12-07 14:40:41', '', '1', '1', '490'), ('124', '2020-12-07 17:02:31', '', '1', '2', '700'), ('125', '2020-12-07 17:14:26', '', '1', '2', '600'), ('126', '2020-12-09 20:16:16', '', '1', '2', '600'), ('127', '2020-12-09 20:48:55', '', '1', '2', '600');
COMMIT;

-- ----------------------------
--  Table structure for `suiwei_chg_qusi`
-- ----------------------------
DROP TABLE IF EXISTS `suiwei_chg_qusi`;
CREATE TABLE `suiwei_chg_qusi` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `tj_ins_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '统计实例标识',
  `mon_or_week` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '月或周(week - 周, month - 月)',
  `mw_val` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '月或周标识',
  `suiwei_val` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '水位值',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='平均水位变化趋势';

-- ----------------------------
--  Records of `suiwei_chg_qusi`
-- ----------------------------
BEGIN;
INSERT INTO `suiwei_chg_qusi` VALUES ('1', 'string', 'week', '01', '300'), ('2', 'string', 'week', '02', '600'), ('3', 'string', 'week', '03', '400'), ('4', 'string', 'week', '04', '500'), ('5', 'string', 'week', '05', '300'), ('11', 'string', 'month', '01', '500'), ('12', 'string', 'month', '02', '400'), ('13', 'string', 'month', '03', '100'), ('14', 'string', 'month', '04', '700'), ('15', 'string', 'month', '05', '900'), ('16', 'string', 'week', '06', '400'), ('17', 'string', 'month', '06', '400'), ('18', 'string', 'week', '07', '900'), ('19', 'string', 'week', '08', '200'), ('21', 'string', 'month', '07', '100'), ('22', 'string', 'week', '08', '100'), ('23', 'c7ad7e9165864677b4a64372e55df1c4', 'week', '01', '200'), ('24', '92f1cf4e6e024246ae3d2f3399feebd6', 'month', '06', '400'), ('25', '92f1cf4e6e024246ae3d2f3399feebd6', 'week', '07', '900'), ('26', '92f1cf4e6e024246ae3d2f3399feebd6', 'week', '08', '200'), ('27', '92f1cf4e6e024246ae3d2f3399feebd6', 'month', '07', '100'), ('28', '92f1cf4e6e024246ae3d2f3399feebd6', 'week', '08', '100'), ('29', '92f1cf4e6e024246ae3d2f3399feebd6', 'week', '01', '200'), ('30', '4d178ae5733c42969a2596be4c58f127', 'week', '01', '200'), ('31', '4d178ae5733c42969a2596be4c58f127', 'month', '06', '400'), ('32', '4d178ae5733c42969a2596be4c58f127', 'week', '07', '900'), ('33', '4d178ae5733c42969a2596be4c58f127', 'week', '09', '200'), ('34', '4d178ae5733c42969a2596be4c58f127', 'month', '07', '100'), ('35', '4d178ae5733c42969a2596be4c58f127', 'week', '08', '100'), ('36', '4d178ae5733c42969a2596be4c58f127', 'week', '02', '200'), ('37', '49d19476860d4ec0a9bc6b81be163f8a', 'week', '01', '300'), ('38', '49d19476860d4ec0a9bc6b81be163f8a', 'week', '02', '400'), ('39', '49d19476860d4ec0a9bc6b81be163f8a', 'week', '03', '500'), ('40', '49d19476860d4ec0a9bc6b81be163f8a', 'month', '01', '500'), ('41', '49d19476860d4ec0a9bc6b81be163f8a', 'month', '02', '600'), ('42', '49d19476860d4ec0a9bc6b81be163f8a', 'month', '03', '700'), ('43', '902ea750ba09439b948a65e238c85139', 'week', null, null), ('44', 'ce2535d7bfef4b4cb319907497fd9614', 'week', '01', '300'), ('45', 'ce2535d7bfef4b4cb319907497fd9614', 'week', '02', '400'), ('46', 'ce2535d7bfef4b4cb319907497fd9614', 'month', '01', '300'), ('47', 'ce2535d7bfef4b4cb319907497fd9614', 'month', '02', '200');
COMMIT;

-- ----------------------------
--  Table structure for `suiwei_sensor_num`
-- ----------------------------
DROP TABLE IF EXISTS `suiwei_sensor_num`;
CREATE TABLE `suiwei_sensor_num` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `tj_ins_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '统计实例标识',
  `all_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '总数',
  `suici_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '电子水尺数',
  `suiwei_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '窖井水位仪数',
  `yulian_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '雨量计数',
  `jingai_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '智能井盖数',
  `normal_zb` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '正常数占比',
  `alarm_zb` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '预警数占比',
  `warn_zb` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '告警数占比',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='水位监测设备数量';

-- ----------------------------
--  Records of `suiwei_sensor_num`
-- ----------------------------
BEGIN;
INSERT INTO `suiwei_sensor_num` VALUES ('1', 'string', '100', '14', '34', '25', '16', '0.4', '0.2', '0.2'), ('2', 'f1233b6b00e84cd28ecaa1bd4e44824f', '100', '14', '34', '25', '16', '0.4', '0.2', '0.2'), ('3', 'f291f509f5b543a5be95f6b8dab66ad2', '120', '20', '20', '20', '20', '0.5', '0.5', '0.5'), ('4', '1bf1d762e0e54af39416dd74097ad9f1', '120', '21', '21', '21', '21', '0.2', '0.2', '0.2'), ('5', 'ffaaa9db33da4b939aa378a27d1892a6', '100', '100', '100', '100', '100', '0.2', '0.2', '0.2');
COMMIT;

-- ----------------------------
--  Table structure for `suiwei_watch`
-- ----------------------------
DROP TABLE IF EXISTS `suiwei_watch`;
CREATE TABLE `suiwei_watch` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `tj_ins_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '统计实例标识',
  `area_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '区域标识',
  `area_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '区域名称',
  `suiwei_val` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '水位值',
  `normal_vals` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '水位监测异常定义-正常区间',
  `alarm_vals` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '水位监测异常定义-预警区间',
  `warn_vals` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '水位监测异常定义-报警区间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=83 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='水位监测';

-- ----------------------------
--  Records of `suiwei_watch`
-- ----------------------------
BEGIN;
INSERT INTO `suiwei_watch` VALUES ('1', 'string', 'string', '人民路', '200', 'string', 'string', 'string'), ('2', 'string', 'string', '勤政路', '80', 'string', 'string', 'string'), ('3', 'string', 'string', '解放路', '60', 'string', 'string', 'string'), ('4', 'string', 'string', '迎宾路', '900', 'string', 'string', 'string'), ('5', 'string', 'string', '鹏飞路', '300', 'string', 'string', 'string'), ('51', 'string', 'string', '中华北路', '300', 'string', 'string', 'string'), ('52', null, 'string', '人民路', '300', 'string', 'string', 'string'), ('53', 'a2df8d1a972f4bc0a72a0e3a9e480393', 'string', '人民路', '200', 'string', 'string', 'string'), ('54', '3cb4d88676f44ce1ae69562f7c5ab7ef', 'string', '人民路', '300', 'string', 'string', 'string'), ('55', 'a514d1bb524d45e0a38e5141eb34079a', 'string', '人民路', '300', 'string', 'string', 'string'), ('56', '012556b92b984413843dfd1ea4bc3fb0', 'string', '解放路', '400', 'string', 'string', 'string'), ('57', 'd6c70adb75474551991a89d63c30bda0', 'string', '中心路', '200', 'string', 'string', 'string'), ('58', '04c802864b72479ba80360aa0e913644', 'string', '人民路', '300', 'string', 'string', 'string'), ('59', '04c802864b72479ba80360aa0e913644', 'string', '解放路', '400', 'string', 'string', 'string'), ('60', '04c802864b72479ba80360aa0e913644', 'string', '中心路', '200', 'string', 'string', 'string'), ('61', 'fedb86d9ea2345dcac3d4818dab612fc', 'string', '人民路', '300', 'string', 'string', 'string'), ('62', 'fedb86d9ea2345dcac3d4818dab612fc', 'string', '解放路', '400', 'string', 'string', 'string'), ('63', 'fedb86d9ea2345dcac3d4818dab612fc', 'string', '中心路', '200', 'string', 'string', 'string'), ('64', 'fedb86d9ea2345dcac3d4818dab612fc', 'string', '中心路', '200', 'string', 'string', 'string'), ('65', 'fedb86d9ea2345dcac3d4818dab612fc', 'string', '新华路', '200', 'string', 'string', 'string'), ('66', 'f3035aeb463d44b39e81983054e49cd4', 'string', '人民路', '600', 'string', 'string', 'string'), ('67', 'f3035aeb463d44b39e81983054e49cd4', 'string', '解放路', '600', 'string', 'string', 'string'), ('68', 'f3035aeb463d44b39e81983054e49cd4', 'string', '中心路', '600', 'string', 'string', 'string'), ('69', 'f3035aeb463d44b39e81983054e49cd4', 'string', '中心路', '300', 'string', 'string', 'string'), ('70', 'f3035aeb463d44b39e81983054e49cd4', 'string', '新华路', '300', 'string', 'string', 'string'), ('71', '4825af9db97048c2a317117901963a37', 'string', '人民路', '500', 'string', 'string', 'string'), ('72', '4825af9db97048c2a317117901963a37', 'string', '解放路', '300', 'string', 'string', 'string'), ('73', '4825af9db97048c2a317117901963a37', 'string', '中心路', '600', 'string', 'string', 'string'), ('74', '4825af9db97048c2a317117901963a37', 'string', '中心路', '300', 'string', 'string', 'string'), ('75', '4825af9db97048c2a317117901963a37', 'string', '新华路', '300', 'string', 'string', 'string'), ('76', '193b2dd396dd4db5a4b110abe67b23c0', '1', '人民路', '200', '200', '200', '200'), ('77', '193b2dd396dd4db5a4b110abe67b23c0', '2', '解放路', '200', '200', '200', '200'), ('78', '193b2dd396dd4db5a4b110abe67b23c0', '3', '中心路', '200', '200', '200', '200'), ('79', '193b2dd396dd4db5a4b110abe67b23c0', '4', '中华路', '200', '200', '200', '200'), ('80', 'c280d4d1eecd44a4899fe299771c60db', '1', '人民路', '300', '300', '300', '300'), ('81', 'c280d4d1eecd44a4899fe299771c60db', '2', '中华路', '200', '200', '200', '200'), ('82', 'c280d4d1eecd44a4899fe299771c60db', '3', '中心路', '100', '100', '100', '100');
COMMIT;

-- ----------------------------
--  Table structure for `suizi_sensor_num`
-- ----------------------------
DROP TABLE IF EXISTS `suizi_sensor_num`;
CREATE TABLE `suizi_sensor_num` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `tj_ins_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '统计实例标识',
  `all_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '总数',
  `ch2_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'CH2传感器数',
  `h2s_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'H2S传感器数',
  `co_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'CO传感器数',
  `ph_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'PH传感器数',
  `normal_zb` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '正常数占比',
  `alarm_zb` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '预警数占比',
  `warn_zb` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '告警数占比',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='水质监测设备数量';

-- ----------------------------
--  Records of `suizi_sensor_num`
-- ----------------------------
BEGIN;
INSERT INTO `suizi_sensor_num` VALUES ('1', 'tjInsId1', '100', '43', '23', '33', '13', '0.7', '0.2', '0.1'), ('2', 'c9a78c3bed15439e803df0094711cf75', '100', '43', '23', '33', '13', '0.7', '0.2', '0.1'), ('3', '2b8c0ea4e72c4e15a6961393f22bc356', '100', '44', '24', '34', '14', '0.7', '0.2', '0.1'), ('4', 'e90fcd80ddfb4a7d839261fcb547bd09', '100', '45', '25', '35', '15', '0.5', '0.5', '0.5'), ('5', 'ea6a26a234be47e198a4611da3dbc386', '100', '100', '100', '100', '100', '0.2', '0.2', '0.2');
COMMIT;

-- ----------------------------
--  Table structure for `t_user`
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
  `id` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'ID',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '姓名',
  `code` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '账号',
  `pass_word` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '密码',
  `nickname` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '昵称++',
  `sex` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '性别',
  `phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '电话',
  `real_name_state` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '是否实名认证++',
  `id_card` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '身份证号++',
  `last_login_time` datetime DEFAULT NULL COMMENT '最后登录时间++',
  `face_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '人脸识别标识++',
  `weixin_oper_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '微信默认标识++',
  `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '备注',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `rec_state` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '记录状态，有效、已删除',
  `rec_state_date` datetime DEFAULT NULL COMMENT '记录状态时间',
  `partition_city_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '分区城市标识',
  `partition_year` varchar(4) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '分区年份',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='人员';

-- ----------------------------
--  Table structure for `this_day_suizi`
-- ----------------------------
DROP TABLE IF EXISTS `this_day_suizi`;
CREATE TABLE `this_day_suizi` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `tj_ins_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '统计实例标识',
  `today_ch2` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '今日CH2浓度',
  `today_h2s` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '今日H2S浓度',
  `today_co` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '今日CO浓度',
  `today_ph` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '今日PH值',
  `today_zd` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '今日浊度',
  `today_ryl` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '今日溶氧率',
  `prev_day_ch2` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '昨日CH2浓度',
  `prev_day_h2s` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '昨日H2S浓度',
  `prev_day_co` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '昨日CO浓度',
  `prev_day_ph` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '昨日PH值',
  `prev_day_zd` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '昨日浊度',
  `prev_day_ryl` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '昨日溶氧率',
  `ch2_ton_bi` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'CH2浓度同比：1-上升，2-下降，3-不变',
  `h2s_ton_bi` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'H2S浓度同比 1-上升，2-下降，3-不变',
  `co_ton_bi` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'CO浓度同比 1-上升，2-下降，3-不变',
  `ph_ton_bi` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'PH值同比 1-上升，2-下降，3-不变',
  `zd_ton_bi` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '浊度同比 1-上升，2-下降，3-不变',
  `ryl_ton_bi` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '溶氧率同比 1-上升，2-下降，3-不变',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='当日水质检测值';

-- ----------------------------
--  Records of `this_day_suizi`
-- ----------------------------
BEGIN;
INSERT INTO `this_day_suizi` VALUES ('1', 'string', '400', '500', '900', '0.23mg/l', '0.23mg/l', '0.23mg/l', '800', '800', '800', '0.25mg/l', '0.25mg/l', '0.25mg/l', '1', '1', '1', '1', '2', '1'), ('2', '88c3f5cae3024dc9864ed42a7ff8eb6a', '400', '500', '900', '0.23mg/l', '0.23mg/l', '0.23mg/l', '800', '800', '800', '0.25mg/l', '0.25mg/l', '0.25mg/l', '1', '1', '1', '1', '2', '1'), ('3', '32765a13f2f14774b2e341e36259733d', '400', '500', '900', '0.23mg/l', '0.23mg/l', '0.23mg/l', '800', '800', '800', '0.25mg/l', '0.25mg/l', '0.25mg/l', '2', '2', '2', '2', '2', '2'), ('4', '39a05860c392494abce91e8700c92029', '400', '500', '900', '0.23mg/l', '0.23mg/l', '0.23mg/l', '800', '800', '800', '0.25mg/l', '0.25mg/l', '0.25mg/l', '1', '1', '1', '1', '1', '1'), ('5', '048d57100bd8454aab8ab6732e669445', '10', '10', '10', '10', '10', '10', '10', '10', '10', '10', '10', '10', '1', '1', '1', '1', '1', '1');
COMMIT;

-- ----------------------------
--  Table structure for `tj_ins`
-- ----------------------------
DROP TABLE IF EXISTS `tj_ins`;
CREATE TABLE `tj_ins` (
  `id` varchar(36) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'ID',
  `tj_zt_id` int DEFAULT NULL COMMENT '统计主题标识',
  `gen_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '生成方式（预留）',
  `etl_task_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'ETL任务标识（预留）',
  `busi_act_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '业务操作标识（预留）',
  `gen_time` datetime DEFAULT NULL COMMENT '创建时间',
  `rec_state` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '记录状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='统计实例';

-- ----------------------------
--  Records of `tj_ins`
-- ----------------------------
BEGIN;
INSERT INTO `tj_ins` VALUES ('00c81b87abe6454db03fe68d95c2c7bd', '9', null, null, null, '2020-12-11 11:36:35', null), ('012556b92b984413843dfd1ea4bc3fb0', '10', null, null, null, '2020-12-03 12:20:25', null), ('029413409aa248f78a52de0bd631b35e', '14', null, null, null, '2020-12-10 12:04:01', null), ('02cb0e4a408e433e9362765cc9f0b880', '8', null, null, null, '2020-12-11 11:35:59', null), ('048d57100bd8454aab8ab6732e669445', '6', null, null, null, '2020-12-11 11:34:31', null), ('04c802864b72479ba80360aa0e913644', '10', null, null, null, '2020-12-03 12:41:32', null), ('06ac0502310649049e0f8d2cc80f48a9', '19', null, null, null, '2020-12-07 14:14:49', null), ('113a96b393cb48478a6406f105131ea8', '14', null, null, null, '2020-12-07 14:19:57', null), ('193b2dd396dd4db5a4b110abe67b23c0', '10', null, null, null, '2020-12-11 11:37:54', null), ('1974808da7b84dbc8d172aa3c13a126e', '4', null, null, null, '2020-12-04 20:34:13', null), ('1bf1d762e0e54af39416dd74097ad9f1', '11', null, null, null, '2020-12-07 14:11:49', null), ('1f60ece84f9440889a06904ef580637d', '15', null, null, null, '2020-12-04 20:17:01', null), ('291439b7942c4f9b8aeec945e2d77bc3', '18', null, null, null, '2020-12-14 09:47:42', null), ('2a71021a419643caa29302c959579859', '17', null, null, null, '2020-12-14 10:19:45', null), ('2b8c0ea4e72c4e15a6961393f22bc356', '12', null, null, null, '2020-12-04 13:15:46', null), ('32765a13f2f14774b2e341e36259733d', '6', null, null, null, '2020-12-04 12:50:43', null), ('38a452ff2cee410092f2b6286fa99402', '16', null, null, null, '2020-12-04 20:25:04', null), ('39a05860c392494abce91e8700c92029', '6', null, null, null, '2020-12-07 14:13:56', null), ('3cb4d88676f44ce1ae69562f7c5ab7ef', '10', null, null, null, '2020-12-03 12:18:52', null), ('4825af9db97048c2a317117901963a37', '10', null, null, null, '2020-12-07 16:55:29', null), ('49d19476860d4ec0a9bc6b81be163f8a', '5', null, null, null, '2020-12-11 11:33:56', null), ('4a00d6ee26334a809f9fce97ff3f9abc', '7', null, null, null, '2020-12-11 11:35:37', null), ('4d178ae5733c42969a2596be4c58f127', '5', null, null, null, '2020-12-07 14:09:54', null), ('5122dfb8173d4cf88e6090395cb3de50', '17', null, null, null, '2020-12-10 12:09:15', null), ('53cc3346ea0a4357b82e4c175cbc144c', '1', null, null, null, '2020-12-04 20:27:28', null), ('576a872060954e889703c32a0712b4d3', '18', null, null, null, '2020-12-07 14:17:45', null), ('67db688e270b4ea1800493cb76a01309', '14', null, null, null, '2020-12-13 08:44:11', null), ('6dcd3d5a1ec84483a775f68ab6d258c6', '16', null, null, null, '2020-12-07 14:18:14', null), ('6e3211b103564394ab298de8ab878bc4', '1', null, null, null, '2020-11-30 12:42:22', null), ('726138f73926497e8991e8397391264e', '17', null, null, null, '2020-12-14 10:18:05', null), ('74fbdb24333342e9bdad0aa3fced4591', '1', null, null, null, '2020-11-30 11:08:34', null), ('788c4c7e7a66462ba5ce1797fa74097e', '16', null, null, null, '2020-12-10 21:10:35', null), ('79e694c91fdb4d81b3797c76c1860f2a', '4', null, null, null, '2020-12-07 14:21:21', null), ('7ca96f9d418c4a2cba2bc4e7c710aac0', '3', null, null, null, '2020-12-07 14:22:18', null), ('7d57b57426bc4ae98fabbabce3c83d51', '19', null, null, null, '2020-12-13 12:35:45', null), ('7e1e7be207524384a6677afa48a7771b', '18', null, null, null, '2020-12-14 11:16:46', null), ('862ee62395dd45f79c506ec7ec996119', '1', null, null, null, '2020-12-02 12:21:41', null), ('866fea9f01f947bf986d133a11d7a246', '19', null, null, null, '2020-12-13 12:20:05', null), ('86815d33e6124ecfa00668f2dc04c5c8', '18', null, null, null, '2020-12-04 20:09:14', null), ('88c3f5cae3024dc9864ed42a7ff8eb6a', '6', null, null, null, '2020-12-04 12:50:07', null), ('8c0ac01e0ff7418a9fb033ee7f398dfb', '1', null, null, null, '2020-12-10 12:17:40', null), ('902ea750ba09439b948a65e238c85139', '5', null, null, null, '2020-12-14 11:09:27', null), ('92f1cf4e6e024246ae3d2f3399feebd6', '5', null, null, null, '2020-12-03 13:06:33', null), ('9a4664723fcf4724a573a4b86ddf98a0', '19', null, null, null, '2020-12-13 13:04:56', null), ('9cdf312a54b24aaba31edf9e35f30fba', '7', null, null, null, '2020-12-04 21:09:45', null), ('9d4ec90126e04f4b8e0b44f2b4985b42', '8', null, null, null, '2020-12-07 14:10:29', null), ('9fbcb13599644e56a11aa8af8c26e247', '4', null, null, null, '2020-12-11 11:32:37', null), ('a1d6361cab36429bbfb47b920c78dd83', '19', null, null, null, '2020-12-13 12:38:55', null), ('a2df8d1a972f4bc0a72a0e3a9e480393', '10', null, null, null, '2020-12-03 12:16:04', null), ('a514d1bb524d45e0a38e5141eb34079a', '10', null, null, null, '2020-12-03 12:20:25', null), ('a96b18021ad34258b67830526e552087', '15', null, null, null, '2020-12-07 14:17:04', null), ('b5906ce17d474bc8b380dfa7421ba4f8', '19', null, null, null, '2020-12-04 13:02:43', null), ('b8a9c852835f4f7dbc51bc74ffe5645d', '1', null, null, null, '2020-11-30 12:47:34', null), ('b96f64cee59845d09f68ac6585ad481a', '14', null, null, null, '2020-12-13 08:45:15', null), ('ba05394e16eb4740b578465b4448e481', '13', null, null, null, '2020-12-07 14:24:58', null), ('ba67a33789ca48acb0591b46ee9a73e3', '17', null, null, null, '2020-12-07 14:16:21', null), ('c280d4d1eecd44a4899fe299771c60db', '10', null, null, null, '2020-12-13 19:56:15', null), ('c28afd149ab3459e826c0108c782f585', '3', null, null, null, '2020-12-04 20:57:19', null), ('c2aeecd78828455388ae1c3bef8dfa21', '14', null, null, null, '2020-12-04 19:59:42', null), ('c640ae22c3f947f584b5a27aa43869bc', '9', null, null, null, '2020-12-04 12:33:39', null), ('c7ad7e9165864677b4a64372e55df1c4', '5', null, null, null, '2020-12-03 13:05:15', null), ('c8c2811289d8417c8f898517bbe8d1a4', '1', null, null, null, '2020-11-30 12:46:16', null), ('c9a78c3bed15439e803df0094711cf75', '12', null, null, null, '2020-12-04 13:15:27', null), ('cbedd221ee96486fb062be79660ec917', '1', null, null, null, '2020-12-02 12:22:11', null), ('ce2535d7bfef4b4cb319907497fd9614', '5', null, null, null, '2020-12-14 11:16:26', null), ('cf0b3000a4c94dcbb6a60068b6b90017', '7', null, null, null, '2020-12-07 14:23:35', null), ('cf930971688643c095028eb9a5ebe1c2', '15', null, null, null, '2020-12-04 20:17:22', null), ('d026cb8c8e624b63abe30c25855767eb', '17', null, null, null, '2020-12-04 13:31:59', null), ('d03df4a08917465ea190cb471b44afd8', '14', null, null, null, '2020-12-04 19:58:56', null), ('d341e1746b004909b218fdfc3af5c7ca', '9', null, null, null, '2020-12-07 14:13:02', null), ('d6c70adb75474551991a89d63c30bda0', '10', null, null, null, '2020-12-03 12:20:26', null), ('d9489b412d8c4723a806635e239f6459', '15', null, null, null, '2020-12-10 21:15:02', null), ('d9e4358fe74c46508476cef5084535e3', '3', null, null, null, '2020-12-11 11:32:17', null), ('e01d29b2dad741d29bf6dc2e5a3fa99a', '19', null, null, null, '2020-12-13 12:18:56', null), ('e1c7379017034060af69bcfbb90a5ef6', '19', null, null, null, '2020-12-09 21:59:20', null), ('e49d3c35e2ca40538cf9e12006cc861b', '8', null, null, null, '2020-12-03 13:23:39', null), ('e90fcd80ddfb4a7d839261fcb547bd09', '12', null, null, null, '2020-12-07 14:15:37', null), ('ea6a26a234be47e198a4611da3dbc386', '12', null, null, null, '2020-12-11 11:36:53', null), ('eefa8c8e7492443f9aa0fe2372a67584', '1', null, null, null, '2020-12-01 19:43:02', null), ('ef22f5e6b01c4630a4377b06890304eb', '17', null, null, null, '2020-12-04 13:32:18', null), ('f0617232146e40b983473d200726578e', '8', null, null, null, '2020-12-03 13:23:26', null), ('f1233b6b00e84cd28ecaa1bd4e44824f', '11', null, null, null, '2020-12-03 19:25:36', null), ('f246c44ebd89428ab269438a58d00322', '13', null, null, null, '2020-12-04 21:32:44', null), ('f291f509f5b543a5be95f6b8dab66ad2', '11', null, null, null, '2020-12-03 19:26:01', null), ('f3035aeb463d44b39e81983054e49cd4', '10', null, null, null, '2020-12-07 14:08:32', null), ('f8b3e6ffbdc94c08ad4304aac21d5103', '14', null, null, null, '2020-12-04 19:59:29', null), ('fa62480009894b5a8a7dfa8206ee946d', '18', null, null, null, '2020-12-10 11:57:03', null), ('fd4699d2992e4c05890caf38b9de87c0', '14', null, null, null, '2020-12-04 19:59:18', null), ('fea42c2ef6104000be3e373ead0bba56', '1', null, null, null, '2020-12-07 14:19:02', null), ('fedb86d9ea2345dcac3d4818dab612fc', '10', null, null, null, '2020-12-03 12:44:27', null), ('ffaaa9db33da4b939aa378a27d1892a6', '11', null, null, null, '2020-12-11 11:37:06', null);
COMMIT;

-- ----------------------------
--  Table structure for `tj_zt`
-- ----------------------------
DROP TABLE IF EXISTS `tj_zt`;
CREATE TABLE `tj_zt` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
  `last_tj_ins_id` varchar(255) DEFAULT NULL COMMENT '最后统计实例标识',
  `last_tran_etl_task_id` varchar(255) DEFAULT NULL COMMENT '最后转储ETL任务标识（预留）',
  `name` varchar(255) DEFAULT NULL COMMENT '表中文名',
  `tj_ins_detail_table_name` varchar(255) DEFAULT NULL COMMENT '表英文名',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
--  Records of `tj_zt`
-- ----------------------------
BEGIN;
INSERT INTO `tj_zt` VALUES ('1', '8c0ac01e0ff7418a9fb033ee7f398dfb', '', '传感器数量统计表', 'sensor_num_tj'), ('3', 'd9e4358fe74c46508476cef5084535e3', '', '巡检工单数统计', 'xunjian_wo_tj'), ('4', '9fbcb13599644e56a11aa8af8c26e247', '', '工单执行情况统计', 'wo_exec_tj'), ('5', 'ce2535d7bfef4b4cb319907497fd9614', '', '平均水位变化趋势', 'suiwei_chg_qusi'), ('6', '048d57100bd8454aab8ab6732e669445', '', '当日水质检测值', 'this_day_suizi'), ('7', '4a00d6ee26334a809f9fce97ff3f9abc', '', '排障数统计', 'paizan_num_tj'), ('8', '02cb0e4a408e433e9362765cc9f0b880', '', '昨日总体水位', 'prev_day_suiwei'), ('9', '00c81b87abe6454db03fe68d95c2c7bd', '', '毒害物质浓度', 'duhai_rondu'), ('10', 'c280d4d1eecd44a4899fe299771c60db', '', '水位监测', 'suiwei_watch'), ('11', 'ffaaa9db33da4b939aa378a27d1892a6', '', '水位监测设备数量', 'suiwei_sensor_num'), ('12', 'ea6a26a234be47e198a4611da3dbc386', '', '水质监测设备数量', 'suizi_sensor_num'), ('13', 'ba05394e16eb4740b578465b4448e481', '', '管网业务对象数量统计', 'pipe_bo_num_tj'), ('14', 'b96f64cee59845d09f68ac6585ad481a', '', '管道健康情况统计', 'pipe_health_tj'), ('15', 'd9489b412d8c4723a806635e239f6459', '', '管道材质占比统计', 'pipe_mate_tj'), ('16', '788c4c7e7a66462ba5ce1797fa74097e', '', '管道直径占比统计', 'pipe_zijin_tj'), ('17', '2a71021a419643caa29302c959579859', '', '管道长度统计', 'pipe_length_tj'), ('18', '7e1e7be207524384a6677afa48a7771b', '', '管龄统计', 'pipe_years_tj'), ('19', '9a4664723fcf4724a573a4b86ddf98a0', '', '酸碱度', 'area_ph');
COMMIT;

-- ----------------------------
--  Table structure for `wo_exec_tj`
-- ----------------------------
DROP TABLE IF EXISTS `wo_exec_tj`;
CREATE TABLE `wo_exec_tj` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `tj_ins_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '统计实例标识',
  `wo_jd` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '工单执行进度',
  `xunjian_jd` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '巡检执行进度',
  `weixiu_jd` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '维修执行进度',
  `yansou_jd` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '工单验收进度',
  `running_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '在途工单数',
  `this_day_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '今日派单数',
  `reject_zb` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '工单驳回占比',
  `jianxiu_pipe_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '检修管道数',
  `jianxiu_men_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '当前检修人数',
  `jianxiu_all_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '检修岗总人数',
  `xunjian_men_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '当前巡检人数',
  `xunjian_all_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '巡检岗总人数',
  `weixiu_men_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '当前维修人数',
  `weixiu_all_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '维修岗总人数',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='工单执行情况统计';

-- ----------------------------
--  Records of `wo_exec_tj`
-- ----------------------------
BEGIN;
INSERT INTO `wo_exec_tj` VALUES ('1', null, '70', '10', '60', '40', '80', '60', '70', '70', '80', '90', '80', '80', '60', '77'), ('2', '1974808da7b84dbc8d172aa3c13a126e', '70', '10', '60', '40', '80', '60', '70', '70', '80', '90', '80', '80', '60', '77'), ('3', '79e694c91fdb4d81b3797c76c1860f2a', '71', '11', '61', '41', '81', '61', '71', '71', '81', '91', '81', '81', '61', '71'), ('4', '9fbcb13599644e56a11aa8af8c26e247', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70', '70');
COMMIT;

-- ----------------------------
--  Table structure for `xunjian_wo_tj`
-- ----------------------------
DROP TABLE IF EXISTS `xunjian_wo_tj`;
CREATE TABLE `xunjian_wo_tj` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `tj_ins_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '统计实例标识',
  `area_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '区域标识',
  `area_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '区域名称',
  `no_begin_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '未开始数量',
  `no_finish_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '未完成数量',
  `finish_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '已完成数量',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='巡检工单数统计';

-- ----------------------------
--  Records of `xunjian_wo_tj`
-- ----------------------------
BEGIN;
INSERT INTO `xunjian_wo_tj` VALUES ('1', null, 'area1', '片区一', '10', '100', '120'), ('2', null, 'area2', '片区二', '20', '200', '200'), ('3', null, 'area3', '片区三', '30', '300', '150'), ('4', null, 'area4', '片区四', '40', '400', '80'), ('5', null, 'area5', '片区五', '50', '500', '110'), ('6', null, 'area6', '片区六', '100', '100', '100'), ('7', 'c28afd149ab3459e826c0108c782f585', 'area1', '片区一', '10', '100', '120'), ('8', 'c28afd149ab3459e826c0108c782f585', 'area2', '片区二', '20', '200', '200'), ('9', 'c28afd149ab3459e826c0108c782f585', 'area3', '片区三', '30', '300', '150'), ('10', 'c28afd149ab3459e826c0108c782f585', 'area4', '片区四', '40', '400', '80'), ('11', 'c28afd149ab3459e826c0108c782f585', 'area5', '片区五', '50', '500', '110'), ('12', 'c28afd149ab3459e826c0108c782f585', 'area6', '片区六', '100', '100', '100'), ('13', '7ca96f9d418c4a2cba2bc4e7c710aac0', 'area1', '片区一', '10', '100', '120'), ('14', '7ca96f9d418c4a2cba2bc4e7c710aac0', 'area2', '片区二', '20', '200', '200'), ('15', '7ca96f9d418c4a2cba2bc4e7c710aac0', 'area3', '片区三', '30', '300', '150'), ('16', '7ca96f9d418c4a2cba2bc4e7c710aac0', 'area4', '片区四', '40', '400', '80'), ('17', '7ca96f9d418c4a2cba2bc4e7c710aac0', 'area5', '片区五', '50', '500', '110'), ('18', '7ca96f9d418c4a2cba2bc4e7c710aac0', 'area6', '片区六', '200', '200', '300'), ('19', 'd9e4358fe74c46508476cef5084535e3', '1', '片区一', '30', '30', '30'), ('20', 'd9e4358fe74c46508476cef5084535e3', '2', '片区二', '30', '30', '30'), ('21', 'd9e4358fe74c46508476cef5084535e3', '3', '片区三', '30', '30', '30'), ('22', 'd9e4358fe74c46508476cef5084535e3', '4', '片区四', '30', '30', '30'), ('23', 'd9e4358fe74c46508476cef5084535e3', '5', '片区五', '30', '30', '30'), ('24', 'd9e4358fe74c46508476cef5084535e3', '6', '片区六', '30', '30', '30');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
